﻿CREATE TABLE [dbo].[JobTemplate] (
    [JobTemplateId] INT              NOT NULL,
    [JobCategoryId] UNIQUEIDENTIFIER NOT NULL,
    [Description]   NTEXT            NULL,
    [State]         INT              NULL,
    CONSTRAINT [PK_JobTemplate] PRIMARY KEY CLUSTERED ([JobTemplateId] ASC),
    CONSTRAINT [FK_JobTemplate_JobCategory] FOREIGN KEY ([JobCategoryId]) REFERENCES [dbo].[JobCategory] ([JobCategoryId])
);

